<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!-- saved from url=(0163)https://mooc1.chaoxing.com/mooc2/work/view?courseId=218839436&classId=48570730&cpi=210965704&workId=17167246&answerId=50729161&enc=4c30d727aac13a093b349b8ac22aa045 -->
<html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

<title>作业详情</title>
<link rel="stylesheet" type="text/css" href="./第三章SQL语言作业-2021_files/pop.css">
<link rel="stylesheet" type="text/css" href="./第三章SQL语言作业-2021_files/common.css">
<link rel="stylesheet" type="text/css" href="./第三章SQL语言作业-2021_files/marking_icon.css">
<link rel="stylesheet" type="text/css" href="./第三章SQL语言作业-2021_files/viewStudent.css">
<link rel="stylesheet" type="text/css" href="./第三章SQL语言作业-2021_files/taskStudent_pop.css">
<script type="text/javascript" src="./第三章SQL语言作业-2021_files/jquery.min.js.下载"></script>
<script type="text/javascript" src="./第三章SQL语言作业-2021_files/jquery-migrate.min.js.下载"></script><script type="text/javascript" src="./第三章SQL语言作业-2021_files/jquery.nicescroll.min.js.下载"></script>
<script type="text/javascript" src="./第三章SQL语言作业-2021_files/pop.js.下载"></script>
<script type="text/javascript" src="./第三章SQL语言作业-2021_files/poplayout.js.下载"></script>
<script type="text/javascript" src="./第三章SQL语言作业-2021_files/viewStudent.js.下载"></script>
<link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
<script src="./第三章SQL语言作业-2021_files/attach-mark.js.下载"></script>
<style>
.questionLi img{max-width:100%;}
</style><style>.clearfix:after{content: " ";display: block;height: 0px;clear: both;}</style></head>

<body style="zoom: 1; background: transparent;">
<script src="./第三章SQL语言作业-2021_files/preview-attach.js.下载" class="clearfix"></script><link href="./第三章SQL语言作业-2021_files/viewer.min.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="./第三章SQL语言作业-2021_files/jquery.md5.js.下载"></script>
<script type="text/javascript" src="./第三章SQL语言作业-2021_files/viewer-jquery.min.js.下载"></script>
<script type="text/javascript">
try{
	$(function(){
		var imgList = $(".TiMu").find("div img:not(.workAttach img, .attach img, .attachNew img, .stuAnswerArea img, .popClose img, .ans-formula-moudle)");
		for (var i = 0, len = imgList.size(); i < len; i++) {
			 var src = imgList.eq(i).attr("src");
			 if(src){
    			var index = src.indexOf("375_1024");
    			if (index != -1) {
    				src = src.replace("375_1024", "origin");
    			}
                 var index2 = src.indexOf("750_1024");
                 if (index2 != -1) {
                     src = src.replace("750_1024", "origin");
                 }
    			imgList.eq(i).attr("data-original", src);
		   }
		}
        $(".TiMu").find("div img:not(.workAttach img, .attach img, .attachNew img, .stuAnswerArea img, .popClose img)").viewer({
			url : 'data-original',
		});
				        //开始写============================
						$(".mark_table .mark_item").find('.questionLi').each(function(i){

						$(this).prepend("<form class='foo"+i+"' onclick='handler("+i+")'></form>");
						$(this).find(".mark_letter").prependTo(".foo"+i)
						$(this).find("h3").prependTo(".foo"+i)
						$(this).find(".mark_answer").appendTo(".foo"+i)


						$(this).find('.mark_letter li').each(function(){
							$(this).prepend("<input class='calssp' name='Fruit' type='radio' value='' />");
						});
						});

						$(".mark_answer").css({"display": "none"});
						$("span:contains('我的答案:')").remove();
	})
	function handler(i){
		$(".foo"+i).find(".mark_answer").css({"display": "block"})
		console.log(i)
	}
  }catch(error){}
</script>

<input type="hidden" id="courseId" value="218839436">
<input type="hidden" id="classId" value="48570730">
<input type="hidden" id="cpi" value="210965704">
<input type="hidden" id="workId" value="17167246">
<input type="hidden" id="answerId" value="50729161">
<input type="hidden" id="enc" value="4c30d727aac13a093b349b8ac22aa045">
<input type="hidden" id="creatorId" value="210965704">

<div class="subNav">作业详情</div>
<div class="het40"></div>
<div class="fanyaMarking TiMu" id="fanyaMarking">
	<div class="fanyaMarking_left whiteBg">
		<div class="borderBom padBom20 detailsHead">
						<div style="padding: 50px 20px !important;">
				<ul class="nav navbar-nav">
		            <li class="active"><a href="./第一章作业2021.htm">第一章作业</a></li>
		            <li><a href="./第二章作业2021.html">第二章SQL语言作业</a></li>
		            <li><a href="./第三章SQL语言作业2021.html">第三章SQL语言作业</a></li>
       		 	</ul>
			</div>
			<h2 class="mark_title">第三章SQL语言作业-2021</h2>
			<div class="infoHead">
				<span>题量: 53</span>
				<span>满分: 100</span>
				<p class="rightBord">作答时间:<em>12-07 19:16</em>至<em>12-12 23:59</em></p>
							</div>
							<span class="resultNum"><i>100</i>分</span>
					</div>
				
				
							<div class="mark_table padTop60">
													
																						
					
																					
					<div class="mark_item">
						                            <h2 class="type_tit">一. 单选题（共20题，36分）</h2>
																			
																												<div class="marBom60 questionLi" id="question401617030" data="401617030">
								<h3 class="mark_name colorDeep">1. <span class="colorShallow">(单选题)</span>对外连接描述错误的是（&nbsp; &nbsp; ）。</h3>
																	<ul class="mark_letter colorDeep">
																													<li>A. 可以是左外连接</li>
																													<li>B. 可以是右外连接</li>
																													<li>C. 用的是outer join</li>
																																							<li>D. 用的from</li>
																		</ul>
									
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> D</span>
																						<span class="colorGreen marginRight40 fl"><i class="fontWeight">正确答案:</i> D</span>
																					</div>
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																										<span class="marking_dui"></span>
																									</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617031" data="401617031">
								<h3 class="mark_name colorDeep">2. <span class="colorShallow">(单选题)</span>有关视图的作用,下列描述错误的是（&nbsp; &nbsp; ）:</h3>
																	<ul class="mark_letter colorDeep">
																													<li>A. 方便用户,简化操作</li>
																													<li>B. 对机密数据提供安全保护</li>
																																							<li>C. 方便更新数据</li>
																													<li>D. 对重构数据库提供了一定程度的逻辑独立性</li>
																		</ul>
									
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> C</span>
																						<span class="colorGreen marginRight40 fl"><i class="fontWeight">正确答案:</i> C</span>
																					</div>
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																										<span class="marking_dui"></span>
																									</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617033" data="401617033">
								<h3 class="mark_name colorDeep">3. <span class="colorShallow">(单选题)</span>子查询的查询条件依赖于父查询，这类子查询称为（&nbsp; &nbsp; ）。</h3>
																	<ul class="mark_letter colorDeep">
																													<li>A. 不相关子查询</li>
																													<li>B. 连接查询</li>
																													<li>C. 内层查询</li>
																																							<li>D. 相关子查询</li>
																		</ul>
									
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> D</span>
																						<span class="colorGreen marginRight40 fl"><i class="fontWeight">正确答案:</i> D</span>
																					</div>
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																										<span class="marking_dui"></span>
																									</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617034" data="401617034">
								<h3 class="mark_name colorDeep">4. <span class="colorShallow">(单选题)</span>集合操作不包括下列哪一项?（&nbsp; &nbsp; ）</h3>
																	<ul class="mark_letter colorDeep">
																													<li>A. 并操作</li>
																													<li>B. 差操作</li>
																													<li>C. 交操作</li>
																																							<li>D. 连接操作</li>
																		</ul>
									
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> D</span>
																						<span class="colorGreen marginRight40 fl"><i class="fontWeight">正确答案:</i> D</span>
																					</div>
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																										<span class="marking_dui"></span>
																									</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617035" data="401617035">
								<h3 class="mark_name colorDeep">5. <span class="colorShallow">(单选题)</span>下列哪个是查询全体学生学号的代码？（&nbsp; &nbsp; ）</h3>
																	<ul class="mark_letter colorDeep">
																																							<li>A. select sno from student</li>
																													<li>B. select sname from student</li>
																													<li>C. select *</li>
																													<li>D. select student</li>
																		</ul>
									
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> A</span>
																						<span class="colorGreen marginRight40 fl"><i class="fontWeight">正确答案:</i> A</span>
																					</div>
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																										<span class="marking_dui"></span>
																									</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617036" data="401617036">
								<h3 class="mark_name colorDeep">6. <span class="colorShallow">(单选题)</span>下列对SQL的特点表述正确的是（&nbsp; &nbsp; ）。</h3>
																	<ul class="mark_letter colorDeep">
																													<li>A. 高度过程化</li>
																													<li>B. 面向记录的操作方式</li>
																													<li>C. 以多种语法结构提供多种使用方式</li>
																																							<li>D. 综合统一</li>
																		</ul>
									
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> D</span>
																						<span class="colorGreen marginRight40 fl"><i class="fontWeight">正确答案:</i> D</span>
																					</div>
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																										<span class="marking_dui"></span>
																									</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617037" data="401617037">
								<h3 class="mark_name colorDeep">7. <span class="colorShallow">(单选题)</span>以下哪些对象属于内模式（&nbsp; &nbsp; ）？</h3>
																	<ul class="mark_letter colorDeep">
																													<li>A. 视图</li>
																													<li>B. 基本表</li>
																																							<li>C. 存储文件</li>
																													<li>D. 索引</li>
																		</ul>
									
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> C</span>
																						<span class="colorGreen marginRight40 fl"><i class="fontWeight">正确答案:</i> C</span>
																					</div>
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																										<span class="marking_dui"></span>
																									</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617039" data="401617039">
								<h3 class="mark_name colorDeep">8. <span class="colorShallow">(单选题)</span>以下关于查询的叙述正确的是（&nbsp; &nbsp; ）。</h3>
																	<ul class="mark_letter colorDeep">
																													<li>A. 只能根据数据库表创建查询</li>
																																							<li>B. 可以根据数据库表和已建查询创建查询</li>
																													<li>C. 只能根据已建查询创建查询</li>
																													<li>D. 不能根据已建查询创建查询</li>
																		</ul>
									
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> B</span>
																						<span class="colorGreen marginRight40 fl"><i class="fontWeight">正确答案:</i> B</span>
																					</div>
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																										<span class="marking_dui"></span>
																									</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617040" data="401617040">
								<h3 class="mark_name colorDeep">9. <span class="colorShallow">(单选题)</span>以下有关子查询的叙述中不正确的是（&nbsp; &nbsp; ）。</h3>
																	<ul class="mark_letter colorDeep">
																													<li>A. 子查询可以向其外部查询提供检索条件的条件值</li>
																													<li>B. 子查询可以嵌套多层</li>
																													<li>C. 子查询的结果是一个集合&nbsp;</li>
																																							<li>D. 子查询总是先于其外部查询</li>
																		</ul>
									
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> D</span>
																						<span class="colorGreen marginRight40 fl"><i class="fontWeight">正确答案:</i> D</span>
																					</div>
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																										<span class="marking_dui"></span>
																									</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617041" data="401617041">
								<h3 class="mark_name colorDeep">10. <span class="colorShallow">(单选题)</span>具有一组相同数据类型的值的集合是（&nbsp; &nbsp; ）。</h3>
																	<ul class="mark_letter colorDeep">
																																							<li>A. 域</li>
																													<li>B. 笛卡尔积</li>
																													<li>C. 关系</li>
																													<li>D. 实体</li>
																		</ul>
									
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> A</span>
																						<span class="colorGreen marginRight40 fl"><i class="fontWeight">正确答案:</i> A</span>
																					</div>
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																										<span class="marking_dui"></span>
																									</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617042" data="401617042">
								<h3 class="mark_name colorDeep">11. <span class="colorShallow">(单选题)</span>下列哪一个选项不属于SQL的特点?</h3>
																	<ul class="mark_letter colorDeep">
																													<li>A. 面向集合的操作方式</li>
																													<li>B. 高度非过程化</li>
																																							<li>C. 数据结构化</li>
																													<li>D. 综合统一</li>
																		</ul>
									
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> C</span>
																						<span class="colorGreen marginRight40 fl"><i class="fontWeight">正确答案:</i> C</span>
																					</div>
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																										<span class="marking_dui"></span>
																									</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>

																				<div class="analysisDiv">
											<div class="analysis"><i>答案解析：</i><p>SQL的特点包括综合统一、高度非过程化、面向集合的操作方式、以同一种语法结构提供多种使用方式和语言简洁,易学易用。</p></div>
										</div>
										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617043" data="401617043">
								<h3 class="mark_name colorDeep">12. <span class="colorShallow">(单选题)</span>层次模型不能直接表示（&nbsp; &nbsp; ）。</h3>
																	<ul class="mark_letter colorDeep">
																													<li>A. 1:1关系</li>
																													<li>B. 1:m关系</li>
																																							<li>C. m:n关系</li>
																													<li>D. 1:1关系和1:m关系</li>
																		</ul>
									
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> C</span>
																						<span class="colorGreen marginRight40 fl"><i class="fontWeight">正确答案:</i> C</span>
																					</div>
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																										<span class="marking_dui"></span>
																									</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>

																				<div class="analysisDiv">
											<div class="analysis"><i>答案解析：</i><p>1:1关系隐含在基本表,m:n关系必须单独建立关系表</p></div>
										</div>
										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617044" data="401617044">
								<h3 class="mark_name colorDeep">13. <span class="colorShallow">(单选题)</span>在SQL的select-语句中,与选择运算对应的命令动词是（&nbsp; &nbsp; ）。</h3>
																	<ul class="mark_letter colorDeep">
																													<li>A. select-</li>
																													<li>B. FROM</li>
																																							<li>C. WHERE</li>
																													<li>D. ORDER BY</li>
																		</ul>
									
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> C</span>
																						<span class="colorGreen marginRight40 fl"><i class="fontWeight">正确答案:</i> C</span>
																					</div>
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																										<span class="marking_dui"></span>
																									</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617045" data="401617045">
								<h3 class="mark_name colorDeep">14. <span class="colorShallow">(单选题)</span>VALUS子句对新元组的各属性赋值,字符串常数要用（&nbsp; &nbsp; ）括起来。</h3>
																	<ul class="mark_letter colorDeep">
																													<li>A. 双引号</li>
																													<li>B. 括号</li>
																																							<li>C. 单引号</li>
																													<li>D. 双引号或单引号</li>
																		</ul>
									
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> C</span>
																						<span class="colorGreen marginRight40 fl"><i class="fontWeight">正确答案:</i> C</span>
																					</div>
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																										<span class="marking_dui"></span>
																									</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617046" data="401617046">
								<h3 class="mark_name colorDeep">15. <span class="colorShallow">(单选题)</span>下列SQL动词中,属于数据查询的是（&nbsp; &nbsp; ）。</h3>
																	<ul class="mark_letter colorDeep">
																													<li>A. CREATE</li>
																													<li>B. OROP</li>
																																							<li>C. select</li>
																													<li>D. GRANT</li>
																		</ul>
									
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> C</span>
																						<span class="colorGreen marginRight40 fl"><i class="fontWeight">正确答案:</i> C</span>
																					</div>
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																										<span class="marking_dui"></span>
																									</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617048" data="401617048">
								<h3 class="mark_name colorDeep">16. <span class="colorShallow">(单选题)</span>在存在下列关键字的SQL语句中,不可能出现Where子句的是（&nbsp; &nbsp; ）。</h3>
																	<ul class="mark_letter colorDeep">
																													<li>A. Update</li>
																													<li>B. Delete</li>
																													<li>C. Select</li>
																																							<li>D. Alter</li>
																		</ul>
									
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> D</span>
																						<span class="colorGreen marginRight40 fl"><i class="fontWeight">正确答案:</i> D</span>
																					</div>
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																										<span class="marking_dui"></span>
																									</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617050" data="401617050">
								<h3 class="mark_name colorDeep">17. <span class="colorShallow">(单选题)</span>并操作的操作符为（&nbsp; &nbsp; ）。</h3>
																	<ul class="mark_letter colorDeep">
																																							<li>A. UNION</li>
																													<li>B. NOT</li>
																													<li>C. AND</li>
																													<li>D. OR</li>
																		</ul>
									
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> A</span>
																						<span class="colorGreen marginRight40 fl"><i class="fontWeight">正确答案:</i> A</span>
																					</div>
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																										<span class="marking_dui"></span>
																									</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617052" data="401617052">
								<h3 class="mark_name colorDeep">18. <span class="colorShallow">(单选题)</span>数据更新不包括（&nbsp; &nbsp; ）。</h3>
																	<ul class="mark_letter colorDeep">
																													<li>A. 插入数据</li>
																													<li>B. 修改数据</li>
																													<li>C. 删除数据</li>
																																							<li>D. 建立视图</li>
																		</ul>
									
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> D</span>
																						<span class="colorGreen marginRight40 fl"><i class="fontWeight">正确答案:</i> D</span>
																					</div>
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																										<span class="marking_dui"></span>
																									</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617053" data="401617053">
								<h3 class="mark_name colorDeep">19. <span class="colorShallow">(单选题)</span>SQL的数据定义功能不包括（&nbsp; &nbsp; ）。</h3>
																	<ul class="mark_letter colorDeep">
																																							<li>A. 数据查询</li>
																													<li>B. 创建表</li>
																													<li>C. 修改视图</li>
																													<li>D. 删除索引</li>
																		</ul>
									
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> A</span>
																						<span class="colorGreen marginRight40 fl"><i class="fontWeight">正确答案:</i> A</span>
																					</div>
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																										<span class="marking_dui"></span>
																									</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617054" data="401617054">
								<h3 class="mark_name colorDeep">20. <span class="colorShallow">(单选题)</span>能用select-from-where实现的连接查询不包括（&nbsp; &nbsp; ）。</h3>
																	<ul class="mark_letter colorDeep">
																													<li>A. 等值与非等值连接查询</li>
																													<li>B. 自身连接</li>
																																							<li>C. 外连接</li>
																													<li>D. 多表连接</li>
																		</ul>
									
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> C</span>
																						<span class="colorGreen marginRight40 fl"><i class="fontWeight">正确答案:</i> C</span>
																					</div>
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																										<span class="marking_dui"></span>
																									</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>

										
									</div>

															</div>
											</div>
									
																						
					
																					
					<div class="mark_item">
						                            <h2 class="type_tit">二. 填空题（共15题，27分）</h2>
																			
																												<div class="marBom60 questionLi" id="question401617057" data="401617057">
								<h3 class="mark_name colorDeep">21. <span class="colorShallow">(填空题)</span>数据更新的操作有&nbsp;<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</span>,&nbsp;<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</span> ,&nbsp;<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</span> 。</h3>
																	<div class="mark_answer" style="width:760px;">
										<div>
											<dl class="mark_fill colorDeep" id="qb401617057">
												<dt class="positionStyle">
													<i class="fontWeight">我的答案：</i>
																										<div class="mark_score">
														<div class=" fl catalog_tishi80">
															<div class="mark_judge_name"></div>
														</div>
														<div class="totalScore fr"><i>1.8</i>分</div>
													</div>
																									</dt>
																																																																			
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(1) 插入数据</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																																							
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(2) 修改数据</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																																							
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(3) 删除数据</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																				</dl>
											
																						<dl class="mark_fill colorGreen">
												<dt><i class="fontWeight">正确答案：</i></dt>
														    																																																				<dd>(1) 插入数据；插入；插入操作</dd>
		    																																																				<dd>(2) 修改数据；修改；修改操作</dd>
		    																																																				<dd>(3) 删除数据；删除；删除操作</dd>
		    																																	</dl>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617058" data="401617058">
								<h3 class="mark_name colorDeep">22. <span class="colorShallow">(填空题)</span>查询所有姓刘的学生信息：select&nbsp;<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</span> from student&nbsp;<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</span></h3>
																	<div class="mark_answer" style="width:760px;">
										<div>
											<dl class="mark_fill colorDeep" id="qb401617058">
												<dt class="positionStyle">
													<i class="fontWeight">我的答案：</i>
																										<div class="mark_score">
														<div class=" fl catalog_tishi80">
															<div class="mark_judge_name"></div>
														</div>
														<div class="totalScore fr"><i>1.8</i>分</div>
													</div>
																									</dt>
																																																																			
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(1) *</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																																							
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(2) Where Sname like ‘刘%’</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																				</dl>
											
																						<dl class="mark_fill colorGreen">
												<dt><i class="fontWeight">正确答案：</i></dt>
														    																																																				<dd>(1) *</dd>
		    																																																				<dd>(2) Where Sname like ‘刘%’</dd>
		    																																	</dl>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617059" data="401617059">
								<h3 class="mark_name colorDeep">23. <span class="colorShallow">(填空题)</span>更新视图是指通过视图来&nbsp;<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</span> 、&nbsp;<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</span> 和 &nbsp;<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</span>数据。</h3>
																	<div class="mark_answer" style="width:760px;">
										<div>
											<dl class="mark_fill colorDeep" id="qb401617059">
												<dt class="positionStyle">
													<i class="fontWeight">我的答案：</i>
																										<div class="mark_score">
														<div class=" fl catalog_tishi80">
															<div class="mark_judge_name"></div>
														</div>
														<div class="totalScore fr"><i>1.8</i>分</div>
													</div>
																									</dt>
																																																																			
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(1) 插入</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																																							
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(2) 修改</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																																							
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(3) 删除</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																				</dl>
											
																						<dl class="mark_fill colorGreen">
												<dt><i class="fontWeight">正确答案：</i></dt>
														    																																																				<dd>(1) 插入；插入数据</dd>
		    																																																				<dd>(2) 修改;更新；修改数据；更新数据</dd>
		    																																																				<dd>(3) 删除；删除数据</dd>
		    																																	</dl>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617060" data="401617060">
								<h3 class="mark_name colorDeep">24. <span class="colorShallow">(填空题)</span>一个数据库模式中通常包括多个&nbsp;<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</span>、视图和索引等数据库对象。</h3>
																	<div class="mark_answer" style="width:760px;">
										<div>
											<dl class="mark_fill colorDeep" id="qb401617060">
												<dt class="positionStyle">
													<i class="fontWeight">我的答案：</i>
																										<div class="mark_score">
														<div class=" fl catalog_tishi80">
															<div class="mark_judge_name"></div>
														</div>
														<div class="totalScore fr"><i>1.8</i>分</div>
													</div>
																									</dt>
																																																																			
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(1) 表</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																				</dl>
											
																						<dl class="mark_fill colorGreen">
												<dt><i class="fontWeight">正确答案：</i></dt>
														    																																																				<dd>(1) 表;基本表;table；数据表</dd>
		    																																	</dl>
																					</div>

																				<div class="analysisDiv">
											<div class="analysis"><i>答案解析：</i>  </div>
										</div>
										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617062" data="401617062">
								<h3 class="mark_name colorDeep">25. <span class="colorShallow">(填空题)</span>关系数据库的标准语言是&nbsp;<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</span><span style="text-decoration: none;">。</span></h3>
																	<div class="mark_answer" style="width:760px;">
										<div>
											<dl class="mark_fill colorDeep" id="qb401617062">
												<dt class="positionStyle">
													<i class="fontWeight">我的答案：</i>
																										<div class="mark_score">
														<div class=" fl catalog_tishi80">
															<div class="mark_judge_name"></div>
														</div>
														<div class="totalScore fr"><i>1.8</i>分</div>
													</div>
																									</dt>
																																																																			
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(1) SQL</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																				</dl>
											
																						<dl class="mark_fill colorGreen">
												<dt><i class="fontWeight">正确答案：</i></dt>
														    																																																				<dd>(1) 结构化查询语言；SQL语言；SQL</dd>
		    																																	</dl>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617064" data="401617064">
								<h3 class="mark_name colorDeep">26. <span class="colorShallow">(填空题)</span>如果子查询的查询条件依赖于父查询,这类子查询称为&nbsp;<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</span></h3>
																	<div class="mark_answer" style="width:760px;">
										<div>
											<dl class="mark_fill colorDeep" id="qb401617064">
												<dt class="positionStyle">
													<i class="fontWeight">我的答案：</i>
																										<div class="mark_score">
														<div class=" fl catalog_tishi80">
															<div class="mark_judge_name"></div>
														</div>
														<div class="totalScore fr"><i>1.8</i>分</div>
													</div>
																									</dt>
																																																																			
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(1) 相关子查询</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																				</dl>
											
																						<dl class="mark_fill colorGreen">
												<dt><i class="fontWeight">正确答案：</i></dt>
														    																																																				<dd>(1) 相关子查询</dd>
		    																																	</dl>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617065" data="401617065">
								<h3 class="mark_name colorDeep">27. <span class="colorShallow">(填空题)</span>在SQL的9个动词中,创建的动词是&nbsp;<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</span>&nbsp;，查询的动词是&nbsp;<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</span>&nbsp;，删除的动词是&nbsp;<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</span> 和&nbsp;<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</span> 。</h3>
																	<div class="mark_answer" style="width:760px;">
										<div>
											<dl class="mark_fill colorDeep" id="qb401617065">
												<dt class="positionStyle">
													<i class="fontWeight">我的答案：</i>
																										<div class="mark_score">
														<div class=" fl catalog_tishi80">
															<div class="mark_judge_name"></div>
														</div>
														<div class="totalScore fr"><i>1.8</i>分</div>
													</div>
																									</dt>
																																																																			
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(1) CREATE</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																																							
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(2) SELECT</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																																							
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(3) DROP</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																																							
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(4) DELETE</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																				</dl>
											
																						<dl class="mark_fill colorGreen">
												<dt><i class="fontWeight">正确答案：</i></dt>
														    																																																				<dd>(1) CREATE</dd>
		    																																																				<dd>(2) SELECT</dd>
		    																																																				<dd>(3) DROP；DELETE</dd>
		    																																																				<dd>(4) DROP ；DELETE</dd>
		    																																	</dl>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617066" data="401617066">
								<h3 class="mark_name colorDeep">28. <span class="colorShallow">(填空题)</span>where子句与having短语的区别在于<u>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</u>不同。</h3>
																	<div class="mark_answer" style="width:760px;">
										<div>
											<dl class="mark_fill colorDeep" id="qb401617066">
												<dt class="positionStyle">
													<i class="fontWeight">我的答案：</i>
																										<div class="mark_score">
														<div class=" fl catalog_tishi80">
															<div class="mark_judge_name"></div>
														</div>
														<div class="totalScore fr"><i>1.8</i>分</div>
													</div>
																									</dt>
																																																																			
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(1) 作用对象</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																				</dl>
											
																						<dl class="mark_fill colorGreen">
												<dt><i class="fontWeight">正确答案：</i></dt>
														    																																																				<dd>(1) 作用对象</dd>
		    																																	</dl>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617067" data="401617067">
								<h3 class="mark_name colorDeep">29. <span class="colorShallow">(填空题)</span>视图是一个虚表,它是从<span style="text-decoration: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </span>导出的表。在数据库中,只存放视图的<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span>,不存放视图的<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span></h3>
																	<div class="mark_answer" style="width:760px;">
										<div>
											<dl class="mark_fill colorDeep" id="qb401617067">
												<dt class="positionStyle">
													<i class="fontWeight">我的答案：</i>
																										<div class="mark_score">
														<div class=" fl catalog_tishi80">
															<div class="mark_judge_name"></div>
														</div>
														<div class="totalScore fr"><i>1.8</i>分</div>
													</div>
																									</dt>
																																																																			
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(1) 基本表</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																																							
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(2) 定义</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																																							
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(3) 数据</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																				</dl>
											
																						<dl class="mark_fill colorGreen">
												<dt><i class="fontWeight">正确答案：</i></dt>
														    																																																				<dd>(1) 一个或多个基本表；基本表；表；基表；一个或几个基本表</dd>
		    																																																				<dd>(2) 定义</dd>
		    																																																				<dd>(3) 数据</dd>
		    																																	</dl>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617068" data="401617068">
								<h3 class="mark_name colorDeep">30. <span class="colorShallow">(填空题)</span>select语句中,条件表达式可以出现的地方,分别是<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </span><span style="text-decoration: none;">语句和<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span>&nbsp; 语句。</span></h3>
																	<div class="mark_answer" style="width:760px;">
										<div>
											<dl class="mark_fill colorDeep" id="qb401617068">
												<dt class="positionStyle">
													<i class="fontWeight">我的答案：</i>
																										<div class="mark_score">
														<div class=" fl catalog_tishi80">
															<div class="mark_judge_name"></div>
														</div>
														<div class="totalScore fr"><i>1.8</i>分</div>
													</div>
																									</dt>
																																																																			
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(1) where</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																																							
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(2) having</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																				</dl>
											
																						<dl class="mark_fill colorGreen">
												<dt><i class="fontWeight">正确答案：</i></dt>
														    																																																				<dd>(1) where；where语句</dd>
		    																																																				<dd>(2) having;&nbsp;having语句</dd>
		    																																	</dl>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617069" data="401617069">
								<h3 class="mark_name colorDeep">31. <span class="colorShallow">(填空题)</span>在关系数据库系统里,一个关系可以对应<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span>个基本表。</h3>
																	<div class="mark_answer" style="width:760px;">
										<div>
											<dl class="mark_fill colorDeep" id="qb401617069">
												<dt class="positionStyle">
													<i class="fontWeight">我的答案：</i>
																										<div class="mark_score">
														<div class=" fl catalog_tishi80">
															<div class="mark_judge_name"></div>
														</div>
														<div class="totalScore fr"><i>1.8</i>分</div>
													</div>
																									</dt>
																																																																			
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(1) 1</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																				</dl>
											
																						<dl class="mark_fill colorGreen">
												<dt><i class="fontWeight">正确答案：</i></dt>
														    																																																				<dd>(1) 一；1</dd>
		    																																	</dl>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617072" data="401617072">
								<h3 class="mark_name colorDeep">32. <span class="colorShallow">(填空题)</span>SQL集__,__,__的功能于一体。</h3>
																	<div class="mark_answer" style="width:760px;">
										<div>
											<dl class="mark_fill colorDeep" id="qb401617072">
												<dt class="positionStyle">
													<i class="fontWeight">我的答案：</i>
																										<div class="mark_score">
														<div class=" fl catalog_tishi80">
															<div class="mark_judge_name"></div>
														</div>
														<div class="totalScore fr"><i>1.8</i>分</div>
													</div>
																									</dt>
																																																																			
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(1) 数据定义</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																																							
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(2) 数据操纵</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																																							
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(3) 数据控制</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																				</dl>
											
																						<dl class="mark_fill colorGreen">
												<dt><i class="fontWeight">正确答案：</i></dt>
														    																																																				<dd>(1) 数据定义语言；数据定义</dd>
		    																																																				<dd>(2) 数据操纵语言；数据操纵</dd>
		    																																																				<dd>(3) 数据控制语言；数据控制</dd>
		    																																	</dl>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617073" data="401617073">
								<h3 class="mark_name colorDeep">33. <span class="colorShallow">(填空题)</span>两个以上的表进行连接称为<span style="text-decoration: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</span><span style="text-decoration: none;"> 。</span></h3>
																	<div class="mark_answer" style="width:760px;">
										<div>
											<dl class="mark_fill colorDeep" id="qb401617073">
												<dt class="positionStyle">
													<i class="fontWeight">我的答案：</i>
																										<div class="mark_score">
														<div class=" fl catalog_tishi80">
															<div class="mark_judge_name"></div>
														</div>
														<div class="totalScore fr"><i>1.8</i>分</div>
													</div>
																									</dt>
																																																																			
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(1) 多表连接</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																				</dl>
											
																						<dl class="mark_fill colorGreen">
												<dt><i class="fontWeight">正确答案：</i></dt>
														    																																																				<dd>(1) 多表连接；多表连接查询</dd>
		    																																	</dl>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617077" data="401617077">
								<h3 class="mark_name colorDeep">34. <span class="colorShallow">(填空题)</span>连接谓词中的列名称为<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </span><span style="text-decoration: none;">。</span></h3>
																	<div class="mark_answer" style="width:760px;">
										<div>
											<dl class="mark_fill colorDeep" id="qb401617077">
												<dt class="positionStyle">
													<i class="fontWeight">我的答案：</i>
																										<div class="mark_score">
														<div class=" fl catalog_tishi80">
															<div class="mark_judge_name"></div>
														</div>
														<div class="totalScore fr"><i>1.8</i>分</div>
													</div>
																									</dt>
																																																																			
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(1) 连接字段</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																				</dl>
											
																						<dl class="mark_fill colorGreen">
												<dt><i class="fontWeight">正确答案：</i></dt>
														    																																																				<dd>(1) 连接字段</dd>
		    																																	</dl>
																					</div>

										
									</div>

															</div>
													
																												<div class="marBom60 questionLi" id="question401617080" data="401617080">
								<h3 class="mark_name colorDeep">35. <span class="colorShallow">(填空题)</span>SQL的特点是<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </span><span style="text-decoration: none;">、</span><span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </span><span style="text-decoration: none;">、</span><span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </span><span style="text-decoration: none;">、<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</span>、<span style="text-decoration-line: underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</span></span><span style="text-decoration: none;">。</span></h3>
																	<div class="mark_answer" style="width:760px;">
										<div>
											<dl class="mark_fill colorDeep" id="qb401617080">
												<dt class="positionStyle">
													<i class="fontWeight">我的答案：</i>
																										<div class="mark_score">
														<div class=" fl catalog_tishi80">
															<div class="mark_judge_name"></div>
														</div>
														<div class="totalScore fr"><i>1.8</i>分</div>
													</div>
																									</dt>
																																																																			
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(1) 综合统一</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																																							
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(2) 高度非过程化</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																																							
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(3) 面向集合的操作方式</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																																							
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(4) 以同一种语法结构提供多种使用方式</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																																							
														<dd>
															<span class="answer_span" style="display:inline-block;width:94%;">(5) 语言简洁，易学易用</span>
																																															                                                                <span class="marking_dui"></span>
																																																												</dd>
																																				</dl>
											
																						<dl class="mark_fill colorGreen">
												<dt><i class="fontWeight">正确答案：</i></dt>
														    																																																				<dd>(1) 综合统一</dd>
		    																																																				<dd>(2) 高度非过程化</dd>
		    																																																				<dd>(3) 面向集合的操作方式</dd>
		    																																																				<dd>(4) 以同一种语法结构提供多种使用方式</dd>
		    																																																				<dd>(5) 语言简洁,易学易用</dd>
		    																																	</dl>
																					</div>

										
									</div>

															</div>
											</div>
									
																						
					
																					
					<div class="mark_item">
						                            <h2 class="type_tit">三. 判断题（共18题，37分）</h2>
																			
																												<div class="marBom60 questionLi" id="question401617081" data="401617081">
								<h3 class="mark_name colorDeep">36. <span class="colorShallow">(判断题)</span>一个关系数据库管理系统的实例中只能建立一个数据库,一个数据库中只能建立一个模式。</h3>
																	<ul class="mark_letter colorDeep">
										<li>A. 对</li>
										<li>B. 错</li>
									</ul>
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> 错</span>
																						<span class="colorGreen marginRight40 fl">
																											            										        										<i class="fontWeight">正确答案:</i> 错
		            																															</span>
																					</div>
										
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																    									<span class="marking_dui"></span>
			    																					</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>
										
																				<div class="analysisDiv">
											<div class="analysis"><i>答案解析：</i><p>均可以建立多个</p></div>
										</div>
										
									</div>
								
															</div>
													
																												<div class="marBom60 questionLi" id="question401617082" data="401617082">
								<h3 class="mark_name colorDeep">37. <span class="colorShallow">(判断题)</span>在一个表上可以创建一个聚集索引,可以创建多个非聚集索引。</h3>
																	<ul class="mark_letter colorDeep">
										<li>A. 对</li>
										<li>B. 错</li>
									</ul>
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> 对</span>
																						<span class="colorGreen marginRight40 fl">
																											        										<i class="fontWeight">正确答案:</i> 对
		            										            																															</span>
																					</div>
										
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																    									<span class="marking_dui"></span>
			    																					</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>
										
										
									</div>
								
															</div>
													
																												<div class="marBom60 questionLi" id="question401617083" data="401617083">
								<h3 class="mark_name colorDeep">38. <span class="colorShallow">(判断题)</span>空值就是没有值。</h3>
																	<ul class="mark_letter colorDeep">
										<li>A. 对</li>
										<li>B. 错</li>
									</ul>
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> 错</span>
																						<span class="colorGreen marginRight40 fl">
																											            										        										<i class="fontWeight">正确答案:</i> 错
		            																															</span>
																					</div>
										
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																    									<span class="marking_dui"></span>
			    																					</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>
										
										
									</div>
								
															</div>
													
																												<div class="marBom60 questionLi" id="question401617084" data="401617084">
								<h3 class="mark_name colorDeep">39. <span class="colorShallow">(判断题)</span>在关系数据库中,所有的视图都可以更新。</h3>
																	<ul class="mark_letter colorDeep">
										<li>A. 对</li>
										<li>B. 错</li>
									</ul>
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> 错</span>
																						<span class="colorGreen marginRight40 fl">
																											            										        										<i class="fontWeight">正确答案:</i> 错
		            																															</span>
																					</div>
										
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																    									<span class="marking_dui"></span>
			    																					</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>
										
										
									</div>
								
															</div>
													
																												<div class="marBom60 questionLi" id="question401617086" data="401617086">
								<h3 class="mark_name colorDeep">40. <span class="colorShallow">(判断题)</span>子查询的select-语句中不能使用order by 子句。</h3>
																	<ul class="mark_letter colorDeep">
										<li>A. 对</li>
										<li>B. 错</li>
									</ul>
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> 对</span>
																						<span class="colorGreen marginRight40 fl">
																											        										<i class="fontWeight">正确答案:</i> 对
		            										            																															</span>
																					</div>
										
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																    									<span class="marking_dui"></span>
			    																					</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>
										
																				<div class="analysisDiv">
											<div class="analysis"><i>答案解析：</i><p>order by 子句只能对最终查询结果排序</p></div>
										</div>
										
									</div>
								
															</div>
													
																												<div class="marBom60 questionLi" id="question401617087" data="401617087">
								<h3 class="mark_name colorDeep">41. <span class="colorShallow">(判断题)</span>在SQL语句中,谓词“EXISTS”的含义是存在量词。</h3>
																	<ul class="mark_letter colorDeep">
										<li>A. 对</li>
										<li>B. 错</li>
									</ul>
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> 对</span>
																						<span class="colorGreen marginRight40 fl">
																											        										<i class="fontWeight">正确答案:</i> 对
		            										            																															</span>
																					</div>
										
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																    									<span class="marking_dui"></span>
			    																					</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>
										
										
									</div>
								
															</div>
													
																												<div class="marBom60 questionLi" id="question401617088" data="401617088">
								<h3 class="mark_name colorDeep">42. <span class="colorShallow">(判断题)</span>数据库的更新操作包括：增、删、改、查。</h3>
																	<ul class="mark_letter colorDeep">
										<li>A. 对</li>
										<li>B. 错</li>
									</ul>
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> 错</span>
																						<span class="colorGreen marginRight40 fl">
																											            										        										<i class="fontWeight">正确答案:</i> 错
		            																															</span>
																					</div>
										
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																    									<span class="marking_dui"></span>
			    																					</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>
										
																				<div class="analysisDiv">
											<div class="analysis"><i>答案解析：</i>  </div>
										</div>
										
									</div>
								
															</div>
													
																												<div class="marBom60 questionLi" id="question401617089" data="401617089">
								<h3 class="mark_name colorDeep">43. <span class="colorShallow">(判断题)</span>SQL语言是关系数据库语言。</h3>
																	<ul class="mark_letter colorDeep">
										<li>A. 对</li>
										<li>B. 错</li>
									</ul>
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> 对</span>
																						<span class="colorGreen marginRight40 fl">
																											        										<i class="fontWeight">正确答案:</i> 对
		            										            																															</span>
																					</div>
										
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																    									<span class="marking_dui"></span>
			    																					</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>
										
										
									</div>
								
															</div>
													
																												<div class="marBom60 questionLi" id="question401617090" data="401617090">
								<h3 class="mark_name colorDeep">44. <span class="colorShallow">(判断题)</span>基本表是本身独立存在的表,在关系数据库管理系统中一个关系就对应一个基本表。</h3>
																	<ul class="mark_letter colorDeep">
										<li>A. 对</li>
										<li>B. 错</li>
									</ul>
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> 对</span>
																						<span class="colorGreen marginRight40 fl">
																											        										<i class="fontWeight">正确答案:</i> 对
		            										            																															</span>
																					</div>
										
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																    									<span class="marking_dui"></span>
			    																					</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>
										
										
									</div>
								
															</div>
													
																												<div class="marBom60 questionLi" id="question401617091" data="401617091">
								<h3 class="mark_name colorDeep">45. <span class="colorShallow">(判断题)</span>DELETE语句删除的是关于表的定义。</h3>
																	<ul class="mark_letter colorDeep">
										<li>A. 对</li>
										<li>B. 错</li>
									</ul>
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> 错</span>
																						<span class="colorGreen marginRight40 fl">
																											            										        										<i class="fontWeight">正确答案:</i> 错
		            																															</span>
																					</div>
										
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																    									<span class="marking_dui"></span>
			    																					</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>
										
																				<div class="analysisDiv">
											<div class="analysis"><i>答案解析：</i>  </div>
										</div>
										
									</div>
								
															</div>
													
																												<div class="marBom60 questionLi" id="question401617092" data="401617092">
								<h3 class="mark_name colorDeep">46. <span class="colorShallow">(判断题)</span>如果LIKE后面的匹配串中不含通配符,则可以用=运算符取代LIKE谓词,用!=运算符取代NOT LIKE谓词。</h3>
																	<ul class="mark_letter colorDeep">
										<li>A. 对</li>
										<li>B. 错</li>
									</ul>
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> 对</span>
																						<span class="colorGreen marginRight40 fl">
																											        										<i class="fontWeight">正确答案:</i> 对
		            										            																															</span>
																					</div>
										
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																    									<span class="marking_dui"></span>
			    																					</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>
										
										
									</div>
								
															</div>
													
																												<div class="marBom60 questionLi" id="question401617093" data="401617093">
								<h3 class="mark_name colorDeep">47. <span class="colorShallow">(判断题)</span>聚集函数可以在where选择条件中使用。</h3>
																	<ul class="mark_letter colorDeep">
										<li>A. 对</li>
										<li>B. 错</li>
									</ul>
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> 错</span>
																						<span class="colorGreen marginRight40 fl">
																											            										        										<i class="fontWeight">正确答案:</i> 错
		            																															</span>
																					</div>
										
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																    									<span class="marking_dui"></span>
			    																					</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>
										
										
									</div>
								
															</div>
													
																												<div class="marBom60 questionLi" id="question401617096" data="401617096">
								<h3 class="mark_name colorDeep">48. <span class="colorShallow">(判断题)</span>带有EXISTS谓词的子查询不返回任何数据,只产生逻辑真值‘true’或逻辑假值‘false’。</h3>
																	<ul class="mark_letter colorDeep">
										<li>A. 对</li>
										<li>B. 错</li>
									</ul>
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> 对</span>
																						<span class="colorGreen marginRight40 fl">
																											        										<i class="fontWeight">正确答案:</i> 对
		            										            																															</span>
																					</div>
										
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																    									<span class="marking_dui"></span>
			    																					</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>
										
										
									</div>
								
															</div>
													
																												<div class="marBom60 questionLi" id="question401617097" data="401617097">
								<h3 class="mark_name colorDeep">49. <span class="colorShallow">(判断题)</span>数据库中不存放视图对应的数据。</h3>
																	<ul class="mark_letter colorDeep">
										<li>A. 对</li>
										<li>B. 错</li>
									</ul>
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> 对</span>
																						<span class="colorGreen marginRight40 fl">
																											        										<i class="fontWeight">正确答案:</i> 对
		            										            																															</span>
																					</div>
										
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																    									<span class="marking_dui"></span>
			    																					</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>
										
										
									</div>
								
															</div>
													
																												<div class="marBom60 questionLi" id="question401617099" data="401617099">
								<h3 class="mark_name colorDeep">50. <span class="colorShallow">(判断题)</span>嵌套查询都可用连接运算所替代。</h3>
																	<ul class="mark_letter colorDeep">
										<li>A. 对</li>
										<li>B. 错</li>
									</ul>
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> 错</span>
																						<span class="colorGreen marginRight40 fl">
																											            										        										<i class="fontWeight">正确答案:</i> 错
		            																															</span>
																					</div>
										
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																    									<span class="marking_dui"></span>
			    																					</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>
										
										
									</div>
								
															</div>
													
																												<div class="marBom60 questionLi" id="question401617100" data="401617100">
								<h3 class="mark_name colorDeep">51. <span class="colorShallow">(判断题)</span>数据库的‘*’只代表‘乘’或‘全部’。</h3>
																	<ul class="mark_letter colorDeep">
										<li>A. 对</li>
										<li>B. 错</li>
									</ul>
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> 错</span>
																						<span class="colorGreen marginRight40 fl">
																											            										        										<i class="fontWeight">正确答案:</i> 错
		            																															</span>
																					</div>
										
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																    									<span class="marking_dui"></span>
			    																					</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>
										
										
									</div>
								
															</div>
													
																												<div class="marBom60 questionLi" id="question401617101" data="401617101">
								<h3 class="mark_name colorDeep">52. <span class="colorShallow">(判断题)</span>所有视图都是可更新的。</h3>
																	<ul class="mark_letter colorDeep">
										<li>A. 对</li>
										<li>B. 错</li>
									</ul>
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> 错</span>
																						<span class="colorGreen marginRight40 fl">
																											            										        										<i class="fontWeight">正确答案:</i> 错
		            																															</span>
																					</div>
										
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																    									<span class="marking_dui"></span>
			    																					</div>
																							</div>
																						<div class="totalScore fr"><i>1.8</i>分</div>
																					</div>
										
										
									</div>
								
															</div>
													
																												<div class="marBom60 questionLi" id="question401617102" data="401617102">
								<h3 class="mark_name colorDeep">53. <span class="colorShallow">(判断题)</span>视图本身独立存储在数据库中。</h3>
																	<ul class="mark_letter colorDeep">
										<li>A. 对</li>
										<li>B. 错</li>
									</ul>
									<div class="mark_answer">
										<div class="mark_key clearfix">
											<span class="colorDeep marginRight40 fl"><i class="fontWeight">我的答案:</i> 错</span>
																						<span class="colorGreen marginRight40 fl">
																											            										        										<i class="fontWeight">正确答案:</i> 错
		            																															</span>
																					</div>
										
										<div class="mark_score">
											<div class=" fl catalog_tishi80">
																								<div class="mark_judge_name">
																    									<span class="marking_dui"></span>
			    																					</div>
																							</div>
																						<div class="totalScore fr"><i>6.4</i>分</div>
																					</div>
										
										
									</div>
								
															</div>
											</div>
							</div>
			</div>
	
		<div class="fanyaMarking_right" id="rightHeight" style="max-height: 576px; top: 70px;">
		<div class="topicNumber" id="topicNumberScroll" style="max-height: 496px; overflow: hidden; outline: none;" tabindex="1">
												
																										
						
																				
                        <div class="topicNumber_checkbox colorDeep fs14">
							                                <span class="numRight fr"><i>36</i>分</span>
														一. 单选题（36分）                        </div>
                        <ul class="topicNumber_list clearfix">
							                                <li id="answerSheet401617030" data="401617030" class="active">1</li>
							                                <li id="answerSheet401617031" data="401617031" class="active">2</li>
							                                <li id="answerSheet401617033" data="401617033" class="active">3</li>
							                                <li id="answerSheet401617034" data="401617034" class="active">4</li>
							                                <li id="answerSheet401617035" data="401617035" class="active">5</li>
							                                <li id="answerSheet401617036" data="401617036" class="active">6</li>
							                                <li id="answerSheet401617037" data="401617037" class="active">7</li>
							                                <li id="answerSheet401617039" data="401617039" class="active">8</li>
							                                <li id="answerSheet401617040" data="401617040" class="active">9</li>
							                                <li id="answerSheet401617041" data="401617041" class="active">10</li>
							                                <li id="answerSheet401617042" data="401617042" class="active">11</li>
							                                <li id="answerSheet401617043" data="401617043" class="active">12</li>
							                                <li id="answerSheet401617044" data="401617044" class="active">13</li>
							                                <li id="answerSheet401617045" data="401617045" class="active">14</li>
							                                <li id="answerSheet401617046" data="401617046" class="active">15</li>
							                                <li id="answerSheet401617048" data="401617048" class="active">16</li>
							                                <li id="answerSheet401617050" data="401617050" class="active">17</li>
							                                <li id="answerSheet401617052" data="401617052" class="active">18</li>
							                                <li id="answerSheet401617053" data="401617053" class="active">19</li>
							                                <li id="answerSheet401617054" data="401617054" class="active">20</li>
							                        </ul>
					
																										
						
																				
                        <div class="topicNumber_checkbox colorDeep fs14">
							                                <span class="numRight fr"><i>27</i>分</span>
														二. 填空题（27分）                        </div>
                        <ul class="topicNumber_list clearfix">
							                                <li id="answerSheet401617057" data="401617057" class="active">21</li>
							                                <li id="answerSheet401617058" data="401617058" class="active">22</li>
							                                <li id="answerSheet401617059" data="401617059" class="active">23</li>
							                                <li id="answerSheet401617060" data="401617060" class="active">24</li>
							                                <li id="answerSheet401617062" data="401617062" class="active">25</li>
							                                <li id="answerSheet401617064" data="401617064" class="active">26</li>
							                                <li id="answerSheet401617065" data="401617065" class="active">27</li>
							                                <li id="answerSheet401617066" data="401617066" class="active">28</li>
							                                <li id="answerSheet401617067" data="401617067" class="active">29</li>
							                                <li id="answerSheet401617068" data="401617068" class="active">30</li>
							                                <li id="answerSheet401617069" data="401617069" class="active">31</li>
							                                <li id="answerSheet401617072" data="401617072" class="active">32</li>
							                                <li id="answerSheet401617073" data="401617073" class="active">33</li>
							                                <li id="answerSheet401617077" data="401617077" class="active">34</li>
							                                <li id="answerSheet401617080" data="401617080" class="active">35</li>
							                        </ul>
					
																										
						
																				
                        <div class="topicNumber_checkbox colorDeep fs14">
							                                <span class="numRight fr"><i>37</i>分</span>
														三. 判断题（37分）                        </div>
                        <ul class="topicNumber_list clearfix">
							                                <li id="answerSheet401617081" data="401617081" class="active">36</li>
							                                <li id="answerSheet401617082" data="401617082" class="active">37</li>
							                                <li id="answerSheet401617083" data="401617083" class="active">38</li>
							                                <li id="answerSheet401617084" data="401617084" class="active">39</li>
							                                <li id="answerSheet401617086" data="401617086" class="active">40</li>
							                                <li id="answerSheet401617087" data="401617087" class="active">41</li>
							                                <li id="answerSheet401617088" data="401617088" class="active">42</li>
							                                <li id="answerSheet401617089" data="401617089" class="active">43</li>
							                                <li id="answerSheet401617090" data="401617090" class="active">44</li>
							                                <li id="answerSheet401617091" data="401617091" class="active">45</li>
							                                <li id="answerSheet401617092" data="401617092" class="active">46</li>
							                                <li id="answerSheet401617093" data="401617093" class="active">47</li>
							                                <li id="answerSheet401617096" data="401617096" class="active">48</li>
							                                <li id="answerSheet401617097" data="401617097" class="active">49</li>
							                                <li id="answerSheet401617099" data="401617099" class="active">50</li>
							                                <li id="answerSheet401617100" data="401617100" class="active">51</li>
							                                <li id="answerSheet401617101" data="401617101" class="active">52</li>
							                                <li id="answerSheet401617102" data="401617102" class="active">53</li>
							                        </ul>
														</div>
	<div id="ascrail2000" class="nicescroll-rails nicescroll-rails-vr" style="width: 8px; z-index: auto; cursor: default; position: absolute; top: 0px; left: 272px; height: 496px; opacity: 0;"><div class="nicescroll-cursors" style="position: relative; top: 0px; float: right; width: 8px; height: 318px; background-color: rgb(230, 236, 245); background-clip: padding-box; border-radius: 5px;"></div></div><div id="ascrail2000-hr" class="nicescroll-rails nicescroll-rails-hr" style="height: 8px; z-index: auto; top: 488px; left: 0px; position: absolute; cursor: default; display: none; width: 272px; opacity: 0;"><div class="nicescroll-cursors" style="position: absolute; top: 0px; height: 8px; width: 281px; background-color: rgb(230, 236, 245); background-clip: padding-box; border-radius: 5px; left: 0px;"></div></div></div>
	</div>

<div class="maskDiv popMoveShowHide" style="display:none;" id="recordList">
	<div class="popDiv wid640 popMove">
		<div class="popHead">
			<a href="javascript:;" onclick="closeAnswers();" class="popClose popMoveDele fr"><img src="./第三章SQL语言作业-2021_files/popClose.png"></a>
			<p class="fl fs18 colorDeep">作答记录</p>
		</div>
		<div class="het62"></div>
				<div id="content"></div>
	</div>			
</div>

<link rel="stylesheet" type="text/css" href="./第三章SQL语言作业-2021_files/prompt.css">
<style>
	.mask-no-bg{background:none!important;}
	.mask-no-bg .popDiv{box-shadow: 0px 4px 36px rgba(0, 0, 0, 0.08);}
</style>
<div class="maskDiv" style="display:none;" id="workpop">
	<div class="popDiv wid440 Marking">
		<div class="popHead">
			<a href="javascript:;" class="popClose fr" onclick="$(&#39;#workpop&#39;).hide();$(&#39;.popSetupShowHide&#39;).fullFadeOut();"><img src="./第三章SQL语言作业-2021_files/popClose(1).png"></a>
			<p class="fl fs18 colorDeep">提示</p>
		</div>
		<div class="het62"></div>
		<p class="popWord fs16 colorIn" id="popcontent"></p>

		<div class="popBottom">
			<a href="javascript:;" id="popok" class="jb_btn jb_btn_92 fr fs14"></a>
			<a href="javascript:;" id="popno" class="btnBlue btn_92_cancel fr fs14"></a>
		</div>
		<div class="het72"></div>
	</div>
</div>

<div class="mask-no-bg" style="display:none;" id="worktoast">
	<div class="popDiv wid440 Marking" style="top: 30%;">
		<div class="popHead">
			<a href="javascript:;" class="popClose fr" onclick="$(&#39;#worktoast&#39;).hide();$(&#39;.popSetupShowHide&#39;).fullFadeOut();"><img src="./第三章SQL语言作业-2021_files/popClose(1).png"></a>
			<p class="fl fs18 colorDeep">提示</p>
		</div>
		<div class="het62"></div>
		<p class="popWord fs16 colorIn" id="toastcontent"></p>

		<div class="popBottom">
			<a href="javascript:;" id="toastok" class="jb_btn jb_btn_92 fr fs14"></a>
			<a href="javascript:;" id="toastno" class="btnBlue btn_92_cancel fr fs14"></a>
		</div>
		<div class="het72"></div>
	</div>
</div>

<script>

function workPop(content, okTent, cancelTent, okcallback, cancelCallback) {
	var ta = $("#workpop");

	$(".popSetupShowHide").fullFadeIn();
	ta.show();
	
	$("#popcontent").html(content);

	var ok = $("#popok");
	ok.html(okTent);
	ok.unbind();
	ok.on("click", function() {
		okcallback && okcallback(ta);
		ta.hide();
		$(".popSetupShowHide").fullFadeOut();
	});

	var cancel = $("#popno");
	cancel.html(cancelTent);
	cancel.unbind();
	cancel.on("click", function() {
		cancelCallback && cancelCallback(ta);
		ta.hide();
		$(".popSetupShowHide").fullFadeOut();
	});
}

function workToast(content, okTent, cancelTent, okcallback, cancelCallback) {
	var ta = $("#worktoast");

	$(".popSetupShowHide").fullFadeIn();
	ta.show();

	$("#toastcontent").html(content);

	var ok = $("#toastok");
	ok.html(okTent);
	ok.unbind();
	ok.on("click", function() {
		okcallback && okcallback(ta);
		ta.hide();
		$(".popSetupShowHide").fullFadeOut();
	});

	var cancel = $("#toastno");
	cancel.html(cancelTent);
	cancel.unbind();
	cancel.on("click", function() {
		cancelCallback && cancelCallback(ta);
		ta.hide();
		$(".popSetupShowHide").fullFadeOut();
	});
}

</script><script>

var courseId = $("#courseId").val();
var classId = $("#classId").val();
var cpi = $("#cpi").val();
var workId = $("#workId").val();
var answerId = $("#answerId").val();
var enc = $("#enc").val();

function redoWork() {
	
	var redoTimes = 0 + 0 - 0;
	var msg = "你还可以重做" + redoTimes + "次，确认重做后，前一次作答记录会被覆盖，作业成绩以本次成绩为最终成绩，是否继续？";
	
	workPop(msg, "重做", "取消", function() {
		$.ajax({
			type : "get",
			url : "/work/phone/redo",
			dataType : "json",
			data : {
				courseId : courseId,
				classId : classId,
				cpi : cpi,
				workId : workId,
				workAnswerId : answerId
			},
			success : function(data) {
				if(data.status == 1) {
					location.href = "/mooc2/work/dowork?courseId=218839436&classId=48570730&cpi=210965704&workId=17167246&answerId=50729161&knowledgeId=&jobid=&standardEnc=c66c26b9db7e473b5a4285e2004bb70c&enc=4c30d727aac13a093b349b8ac22aa045";
				} else {
					$.toast({
						type : 'failure',
						content : data.msg
					});
				}
			}
		});
	});
}

var recordLock = 0
function answerList() {
	if(recordLock == 1) {
		return;
	}
	recordLock = 1;
	
	$.ajax({
		type : "get",
		url : "/mooc2/work/answer-list",
		dataType : "html",
		data : {
			courseId : courseId,
			classId : classId,
			cpi : cpi,
			workId : workId,
			answerId : answerId,
			enc : enc
		},
		success : function(data) {
			$("#content").html(data);
			$("#recordList").show();
			MoveFixed();
		}
	});
}

function closeAnswers() {
	$("#recordList").hide();
	recordLock = 0;
}

function showAnswer(selectTimes) {
	var url = "/mooc2/work/view?courseId=218839436&classId=48570730&cpi=210965704&workId=17167246&answerId=50729161&enc=4c30d727aac13a093b349b8ac22aa045&selectTimes=" + selectTimes;
	window.open(url);
}

function MoveFixed() {
	$('.popMove').css({
		top : function() {
			return ($(window).height() - $(this).height()) / 2;
		},
		left : function() {
			return ($(window).width() - $(this).width()) / 2;
		}
	});
	
	$("#boxscroll").niceScroll({
		cursorborder : "",
		cursorcolor : "#D9DDE1",
		boxzoom : false
	});
}

</script>


</body></html>